| |
* Group By
:
Calculates a summary value for each group.
|
* Having
:
used in a GROUP BY clause. HAVING clause is like a WHERE clause, but applies only to groups as a whole, whereas the WHERE clause applies to individual rows and it could not be used against aggregate functions (like SUM).
|
* Compute
:
Generates totals that appear as additional summary columns at the end of the result set.
|